UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bq6ptuY9nFs0maAapZIYtdcRZIcEps0eOkZNjldmjbc='
WHERE
key_id = '31bd2bcee2fd81212a6f159d72fdef9bc2e59606fe49eb726baac1589e3717f6'
AND (
token = 'bq6ptuY9nFs0maAapZIYtdcRZIcEps0eOkZNjldmjbc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)