UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rNN8O6XH+1meSe/BhAZjirT053yJHeFQ25Y5g21Uhu8='
WHERE
key_id = '6bcd2954f4649dde096338ca1fd210b3bf29217bd8ef31d05d5efe571ae9a48f'
AND (
token = 'rNN8O6XH+1meSe/BhAZjirT053yJHeFQ25Y5g21Uhu8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)