UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6X99xWH+0frBAopV7llB3PBGp0Az6302uyhc2MaAZn4='
WHERE
key_id = '54821bf0ebe553e8aa8ed3a6389856fdb0467a6332f7e734e7108c925cebdb68'
AND (
token = '6X99xWH+0frBAopV7llB3PBGp0Az6302uyhc2MaAZn4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)