UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Js8rbIfipj7bHwMp5vyrfBzce6RUSgKay4KJVleLzus='
WHERE
key_id = 'd505ad9fe7c9fe544f709bb70c54c7fc33a59c3b13833edaf1c44f9d461b2e66'
AND (
token = 'Js8rbIfipj7bHwMp5vyrfBzce6RUSgKay4KJVleLzus='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)