UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 's0vi5JWZ1Nb9p03DHAXlygoLTDTvaQUQY1Rxwi8KVsQ='
WHERE
key_id = 'c8fabfebe6fa2b659bf72b9e3cb374452b0cdb59e6ebfc30a1408788ce1879ec'
AND (
token = 's0vi5JWZ1Nb9p03DHAXlygoLTDTvaQUQY1Rxwi8KVsQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)