UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zKkQ0xeIUz3WHZU2vpOxEkWdU4yhOH4IywOR9awiJEw='
WHERE
key_id = '355c6c6dadc9e5494bb8f92ca3ca08a8a2df518293dbca9b89453d7f3747f92a'
AND (
token = 'zKkQ0xeIUz3WHZU2vpOxEkWdU4yhOH4IywOR9awiJEw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)