UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'IqaafJP12fwEE7PjO6ekONcG5P/KiopEi/0xw6XLCJU='
WHERE
key_id = '05c60f5d18a7d51ecb335c4978ebac7f2989d0ace29bc0974f46bcd506de7433'
AND (
token = 'IqaafJP12fwEE7PjO6ekONcG5P/KiopEi/0xw6XLCJU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)