UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nQbqTrgXmu1kM+uX7GZF1by46lx58O2sx2VY2kynXKw='
WHERE
key_id = 'd2d492fb9bc677a2f9114cc57c03bea07b0af3ea3210dc8eed5b961a0a30246e'
AND (
token = 'nQbqTrgXmu1kM+uX7GZF1by46lx58O2sx2VY2kynXKw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)