UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/UjtVkm4IIfuKaCX3wMPfd73VCK2sdYYfLPh/KcHw4M='
WHERE
key_id = '51216831505ba892c6b56554a1435ad329d1c9eb10a3a5ad71a1e09b6580f08d'
AND (
token = '/UjtVkm4IIfuKaCX3wMPfd73VCK2sdYYfLPh/KcHw4M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)