UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'loiRClYV3IqTYMsYL3qXRyOJaDnSb0O3o42GDqnzrFU='
WHERE
key_id = 'd3897147e3986152ea025408be64ccff04df4e8a4887c513e42dc35b2dae0111'
AND (
token = 'loiRClYV3IqTYMsYL3qXRyOJaDnSb0O3o42GDqnzrFU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)