UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'v/BPwiiPBnJXsn4WlH+C/zYffLAnU4usbiA+39ErAbc='
WHERE
key_id = 'f2329edcd03108df819f44ac521fa31427edc82d1acdcf4c6ec1f5b1a8ecc71e'
AND (
token = 'v/BPwiiPBnJXsn4WlH+C/zYffLAnU4usbiA+39ErAbc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)