UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3GKF6PtBjR/ccL2X4J55LCGbTjhu1+DczKTJy4yB58U='
WHERE
key_id = '9c9165d6ff89ce6da8857aea77d827e352ef1ae26e4c90a0922af7ce440995e3'
AND (
token = '3GKF6PtBjR/ccL2X4J55LCGbTjhu1+DczKTJy4yB58U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)