UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pFaMsRn/wic8F52fCERcUJjgbyWVDjU8sIKiOr1aXDE='
WHERE
key_id = 'fe7d14e51209d53c8727550dd9d8f38ebbdbfcd430672c7d9e8372cb01b138a5'
AND (
token = 'pFaMsRn/wic8F52fCERcUJjgbyWVDjU8sIKiOr1aXDE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)