UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'X5g0q5QizHFpPYD2G20RbGqI8+FsqRgJn0iAnnE56w8='
WHERE
key_id = 'b9a333cea58d4034f8d8179b9eb00e9e7c7abe22dc2c51dddddb7d16124517f7'
AND (
token = 'X5g0q5QizHFpPYD2G20RbGqI8+FsqRgJn0iAnnE56w8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)