UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'q9eD/74Ei4VpJi82j0H4PuDGuVczBdeHNuBKG9wAfmY='
WHERE
key_id = '96828bd0b802af73a1632b7c2ac902b05b472f0ad132654b07ef8cebf1a3ca36'
AND (
token = 'q9eD/74Ei4VpJi82j0H4PuDGuVczBdeHNuBKG9wAfmY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)