UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'scdC2euZ9qRaCUQtHc+W3HlwC5jY4RSPCmlQa6gnbv4='
WHERE
key_id = '39e2fa6978fd2478f9b313283303c68d060ffa4d6e9f6a747984f9ab4df00847'
AND (
token = 'scdC2euZ9qRaCUQtHc+W3HlwC5jY4RSPCmlQa6gnbv4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)