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