UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'q3MeC9qtqoYHf8NY84S1KiOu8jF7grPix+5d75Ft8TY='
WHERE
key_id = 'ff82a0d38d97d99459b9ce0c43b33e917512f2e2e09792eac106ab08e8ee1cf1'
AND (
token = 'q3MeC9qtqoYHf8NY84S1KiOu8jF7grPix+5d75Ft8TY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)