UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qN1Eq9vd2YZxTZXmJGBJKK0g60CYaVzVl0u3Rt/CqTU='
WHERE
key_id = '2b730c3709f916d6aff72a3f8c1bada6b7afdd12900d8f45227471df34250df7'
AND (
token = 'qN1Eq9vd2YZxTZXmJGBJKK0g60CYaVzVl0u3Rt/CqTU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)