UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9+vvkCc2p3xeVJgjfRg1WpQ+BgEwTAGxd7FKTRBHiP8='
WHERE
key_id = '7f359df6f171a9b547775790183a3f8d5676e01678b43d67f4b38c64c8f5cf23'
AND (
token = '9+vvkCc2p3xeVJgjfRg1WpQ+BgEwTAGxd7FKTRBHiP8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)