UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hPPMGHK+N1hOitAGnrxfturEJlbOmL0QQbS670kQbiQ='
WHERE
key_id = '31d30303b2f7d1570cd7dd2b8169259437def5aabeeee2bca5998b1d22f823bb'
AND (
token = 'hPPMGHK+N1hOitAGnrxfturEJlbOmL0QQbS670kQbiQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)