UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bEOg0HbzTqHnQ+/+8frbNzlgHkWshwyAU5Wo6L+Bvzs='
WHERE
key_id = '24ff62359635a998e85166f9f979c2dd49b44601cec5f23e200af2b32136feee'
AND (
token = 'bEOg0HbzTqHnQ+/+8frbNzlgHkWshwyAU5Wo6L+Bvzs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)