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