UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TjCqbXAOqbeQOCERRAd38n9fDlV8Oei99C5Am1uhf3w='
WHERE
key_id = '7b5b8a7f0f5134e37f7a0ed220830c0b516b48836bb27ee7416c806fc4964ff0'
AND (
token = 'TjCqbXAOqbeQOCERRAd38n9fDlV8Oei99C5Am1uhf3w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)