UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gXuP4UqkV4jieBUXmPkRoNksAV7OjNOBbSWjdVth9GM='
WHERE
key_id = '500bcd55a2b3321ef87f4c61616d07ff4490b6c315dc6337c3c17d4dbb7f0394'
AND (
token = 'gXuP4UqkV4jieBUXmPkRoNksAV7OjNOBbSWjdVth9GM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)