UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'AuCsrhxpxkSdH42pl72krbxsEOTB4DUpH5skjvS/iyc='
WHERE
key_id = '4c336b611b54ea79536176ce3f3c6108588ec4751e2efa73c5630f5771364e0b'
AND (
token = 'AuCsrhxpxkSdH42pl72krbxsEOTB4DUpH5skjvS/iyc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)