UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7+f+A3TVaTqNiUG8ZzL8rXaw7tmDcmG5tpBZyzerez0='
WHERE
key_id = '75bc23e31340909b079e1868f9466669ce2d49045bb3764ef9328c26de25bf28'
AND (
token = '7+f+A3TVaTqNiUG8ZzL8rXaw7tmDcmG5tpBZyzerez0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)