UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pHp7MRz2ViRhLILTvenSEp0hWT3p/dduTtYn1cWiwqQ='
WHERE
key_id = 'afff0fed89a7038e7a8c329bb5e5238438ea5ac920ee9036855a9d299611e334'
AND (
token = 'pHp7MRz2ViRhLILTvenSEp0hWT3p/dduTtYn1cWiwqQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)