UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'd0p9zi0o8jxHjk9jYcy937wUS3DRrra9qNIOvGVfzy4='
WHERE
key_id = 'da4643f427ae58f95b5635347b8b55485492fc586368652a4304be5c9a3337a5'
AND (
token = 'd0p9zi0o8jxHjk9jYcy937wUS3DRrra9qNIOvGVfzy4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)