UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ifZijAorIG0BIXag/txzDgsh3hGaVZsxqs4u2lhWGzQ='
WHERE
key_id = '4b7c3d79e3e48c4c1b6d872cdf24a86294c0f5edb1321c9ac803da97aec47c88'
AND (
token = 'ifZijAorIG0BIXag/txzDgsh3hGaVZsxqs4u2lhWGzQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)