UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3QD1W0CxgV9h9HgxlHkQfU/2/rRuz03Aldm/8DG8TA4='
WHERE
key_id = 'e932b0dc3cb040f17aece325a314c7d6e7903fe07229966c2bdce458f2e21fac'
AND (
token = '3QD1W0CxgV9h9HgxlHkQfU/2/rRuz03Aldm/8DG8TA4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)