UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pX5WD6MF3F40glC+wBYssLtfr/O1P3yrpTHvQn1Pxp4='
WHERE
key_id = 'e84f7231d7180d319ef6528f97b77f9bb2382f87e4b3511034c15419e6401e73'
AND (
token = 'pX5WD6MF3F40glC+wBYssLtfr/O1P3yrpTHvQn1Pxp4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)